home *** CD-ROM | disk | FTP | other *** search
- dDase3
-
- ██████████████████████
- █ BASICS OF DATABASE █
- ██████████████████████
-
- A database is a collection of items that relate
- to each other. For example: if you are the club
- secretary, you would keep a record of the name and address
- of each member.
-
- You would also include with each member a record of their
- dues paid, phone number, birthdays and other personal events.
-
- ▀ If you have a small file box, you would make a file card for
- each member.
- ▀ Each file card is known as a RECORD.
- ▀ The name, address, phone number, and other information
- are each called a FIELD.
-
- ▀ ROWS in a database are called Records (Left to Right).
- ▀ COLUMNS (Up and Down) are called Fields.
-
- ▀ Since each file card in the box contains the same kind of
- of information, the file box is a Database file.
- ▀ The card box contains a database for club members.
-
- FIELDS
-
- ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
- ▓Name: This is called a Field. ▓
- ▓Address: This is called a Field. ▓
- ▓City: This is called a Field. ▓
- ▓State: This is called a Field. ▓
- ▓Zip: This is called a Field. ▓
- ▓Phone: This is called a Field. ▓
- ▓Mortgages This is called a Field ▓
- ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
-
-
- RECORDS (A collection of Fields make a Record)
- ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
- ▓ ▓
- ▓ Name Address City State Zip Phone Mortgages ▓
- ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
- 1 Smith, W 45 State St Lakeland FL 33780 345-6789 Ranch Estates
- 2 Norton,T 123 5th Ave Bartow FL 33833 555-5543 Macon Apartments
-
- ▀ The above display contains 6 Fields.
- ▀ The above display contains 2 Records.
- ▀ The information on Smith and Norton are each called a Record.
- ▀ The 2 Records make up the Database.
- ▀ The Database has been named Mortgages.
-
- This database named "Mortgages" contains information on property
- you sold to Smith and Norton.
-
- The next sale of property, you would add another client to
- your Mortgage database. Since you'll be using the same form
- you will have the same information on each client.
-
- Having the same information on each client makes possible the
- real use of a database, and that is retrieving information.
- You'll be able to retrieve information; like all clients that live
- in particular city, or live in the same zip code area, or
- purchased certain kinds of property.
-
- Databases make it possible to find information you want
- in seconds. For example, if you wanted to know what property
- Smith has, simply locate his name and read across to Mortgages.
-
- Databases are a must for businesses that want to retrieve
- information quickly.
-
-
- *** END OF CHAPTER ***
-
- Press <ESC> key to return to Menu.
-
- Select "CREATING A DATABASE", then press <Enter> key.
-
-
-
-
-